package com.auxgroup.hr.front.dao.repository;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import com.auxgroup.hr.front.dao.domain.PsCEvaDocSecV;
import com.auxgroup.hr.front.dao.domain.PsCEvaDocSecVPrimary;

/**
 * @author lv-PC
 *
 */
@Repository
public interface PsCEvaDocSecVRepository extends
JpaRepository<PsCEvaDocSecV,PsCEvaDocSecVPrimary>,JpaSpecificationExecutor<PsCEvaDocSecV> {
	
	@Query("from PsCEvaDocSecV where cEvaDocId=:docid and cEvaluateRole=:role and cEvaluator=:evaluator order by cEvaSectionSeq")
	public List<PsCEvaDocSecV> getSecSeqs(@Param("docid") String docid,@Param("role") String role, @Param("evaluator") String evaluator);
}